USE [BD_Taller]
GO
/****** Object:  StoredProcedure [dbo].[spConsultarVehiculoPatente]    Script Date: 07/19/2013 13:22:24 ******/
DROP PROCEDURE [dbo].[spConsultarVehiculoPatente]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spConsultarVehiculoPatente]
	@patente varchar(10)
AS
BEGIN
	SET NOCOUNT ON;
	SELECT v.patente,v.year,v.marca,v.modelo,v.chasis
	FROM BD_Taller.dbo.Vehiculo v WHERE v.patente = @patente
END
GO
